Formula1+2

  1. Create a new formula called Formula1+2.
  2. Type the following in the Formula text box of the Formula Editor:

    If {customer.CUSTOMER NAME} [1 to 2] = "Bi" and

    ToText({customer.CUSTOMER ID}) [1] = "6" Then

        "TRUE"

    Else

        "FALSE"

  3. Place the formula to the right of the @Formula4 field.

You should see "TRUE" next to each customer whose name begins with Bi and Id begins with 6, and "FALSE" next to all Customer IDs that do not meet this criteria.

If this formula is working correctly, you can create one last formula adding the code from @Formula3 and @Formula4.

Go on to the FinalFormula.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com